package com.crm.dao;

import com.crm.pojo.Customer;
import com.crm.pojo.CustomerDetail;

import java.sql.SQLException;
import java.util.List;

/**
 * @version : 1.0
 * @auther : hjx
 * @Date : 2021/6/14
 * @Description : 实训
 */
public interface CustomerDao {

    Boolean addCustomer(String custName, String custSource,
                     String custIndustry, String custLevel, String custPhone,
                     String custMobile, String custRegion, long custCapital,
                     String custAddress, String custZip, String custFax,
                     String custWebsite, String custLicence, String custPic,
                     String custCorporation, String custBank) throws SQLException;

    List<Customer> queryCustomer(int start, int pageSize);

    void updateCustomer(int custId,String custName, String custSource,
                        String custIndustry, String custLevel, String custPhone,
                        String custMobile, String custRegion, long custCapital,
                        String custAddress, String custMemo, String custFax,
                        String custWebsite, String custLicence, String custPic,
                        String custCorporation, String custBank);

    void deleteCustomer(int custId);

    List<String> queryCustomerName();

    int qureyCustomerIdByName(String name);

    List<Customer> queryCustomByName(String name);

    Customer queryCustomById(int id);

    CustomerDetail queryCustomDetailById(int id);
}
